import xlrd
from xlutils.copy import copy
wb=xlrd.open_workbook('成绩单.xls')
ws=wb.sheet_by_name('列表应用')
nwb=copy(wb)
nws=nwb.get_sheet('应用结果')
col=ws.col_values(1)[1:]
subtotal,n=0,0
for i in col:
    for score in i.split('-')[1::2]:
       subtotal+=int(score)
    n+=1
    nws.write(n,0,ws.cell_value(n,0))
    nws.write(n,1,subtotal)
    subtotal=0
nwb.save('成绩单.xls')

